You can find XLStart folders in C:\Documents and Settings\username\Application Data\Microsoft\Excel or in C:\Program Files\Microsoft Office\Office11.
Open a workbook automatically when Microsoft Excel starts
If you want to keep the workbook in its current location, use the Create Shortcut command on the File menu to create a shortcut to the workbook, and then move the shortcut to an alternate startup folder.
To open a group of related workbooks when you start Excel, save the workbooks in a workspace file, and then place the workspace file in an alternate startup folder.
Open all files in a folder when Excel starts
Caution Because Excel will attempt to open every file in the alternate startup folder, make sure you specify an empty folder or a folder that contains only files that Excel can open.
Note If a file with the same name is in both the XLStart folder and the alternate startup folder, the file in the XLStart folder opens.
Use startup switches when you start Excel
For example, to open the workbook Actuarial Lists.xls, type a space after the path in the Target box, and then type:
C:\Reference Data\Actuarial Lists.xls
To start Excel and | Type |
---|---|
Open a specific workbook | workbook path/file name |
Open a specific workbook as read-only | /r workbook path/file name |
Prevent display of the Excel startup screen and a new blank workbook | /e |
Specify the working folder
Note The folder specified in the startup switch is used instead of the location specified in the Default file location box on the General tab (Tools menu, Options command). |
/p folder path/folder name |
Specify Office Safe Mode | /safe |
Note Your custom shortcut may be replaced by a Windows Installer shortcut if you name the shortcut Microsoft Excel, and either of the following are true:
If a Windows Installer shortcut replaces your custom shortcut, you must re-create your custom, non-Windows Installer, shortcuts.
Stop a workbook from loading when Excel starts
This procedure clears all ways in which a workbook could be loaded.
Start Excel without running automatic macros
Automatic macros, such as Auto_Open, are designed to run when you start Excel. For more information about these macros, see Microsoft Visual Basic Help.
Note If you start Excel from the Office Shortcut Bar, click the Microsoft Excel button on the Office Shortcut Bar first, and then immediately hold down SHIFT while Excel starts.
Cell and sheet formats. Set by using the commands on the Format menu.
Page formats and print area settings for each sheet.
Cell styles.
The number and type of sheets in a workbook.
Protected and hidden areas of the workbook. You can hide sheets, rows, and columns and prevent changes to worksheet cells.
Text you want to repeat, such as page headers and row and column labels.
Data, graphics, formulas, charts, and other information.
Data validation settings.
Custom toolbars, macros, hyperlinks, and ActiveX controls on forms. To make a custom toolbar available, attach the toolbar to the template.
Workbook calculation options and window view options. Set with the Options command (Tools menu).
Decide which type of template you want:
Workbook template
Create a workbook that contains the sheets, default text (such as page headers and column and row labels), formulas, macros, styles, and other formatting you want in new workbooks based on the template.
Worksheet template
Create a workbook that contains one worksheet. On the worksheet, include the formatting, styles, text, and other information you want to appear on all new sheets of the same type.
To display a picture of the first page of a template in the Preview box of the Templates dialog box (General Templates..., New Workbook task pane), click Properties on the File menu, click the Summary tab, and then select the Save preview picture check box.
On the File menu, click Save As.
In the Save as type box, click Template.
In the Save in box, select the folder where you want to store the template.
To create the default workbook template or default worksheet template, select either the XLStart folder or the alternate startup folder. The XLStart folder is usually
C:\Program Files\Microsoft Office\Office11\XLStart
To create a custom workbook or worksheet template, select the Templates folder, which is usually
C:\Documents and Settings\user_name\Application Data\Microsoft\Templates
Enter the name of the template in the File name box. Do one of the following:
Workbook template
Type book to create the default workbook template.
To create a custom workbook template, type any valid file name.
Worksheet template
Type sheet to create a template for default worksheets.
To create a custom sheet template, type any valid file name.
Click Save, and then click Close on the File menu.